CREATE TABLE [dbo].[SalutationRef]
(
[SalutationKey] [uniqueidentifier] NOT NULL,
[SalutationDesc] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IndividualFormula] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsDefault] [bit] NOT NULL CONSTRAINT [DF_SalutationRef_IsDefault] DEFAULT ((0)),
[IsOverrideable] [bit] NOT NULL CONSTRAINT [DF_SalutationRef_IsOverrideable] DEFAULT ((0)),
[IsActive] [bit] NOT NULL CONSTRAINT [DF_SalutationRef_IsActive] DEFAULT ((0)),
[AutoCreateFlag] [bit] NOT NULL CONSTRAINT [DF_SalutationRef_AutoCreateFlag] DEFAULT ((0)),
[InstituteFormula] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NeedsGenerationFlag] [bit] NOT NULL CONSTRAINT [DF_SalutationRef_NeedsGenerationFlag] DEFAULT ((0)),
[NeedsUpdateFlag] [bit] NOT NULL CONSTRAINT [DF_SalutationRef_NeedsUpdateFlag] DEFAULT ((0))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[SalutationRef] ADD CONSTRAINT [PK_SalutationRef] PRIMARY KEY CLUSTERED ([SalutationKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SalutationRef] ADD CONSTRAINT [AK_SalutationRef_SalutationDesc] UNIQUE NONCLUSTERED ([SalutationDesc]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SalutationRef] ADD CONSTRAINT [FK_SalutationRef_UniformRegistry] FOREIGN KEY ([SalutationKey]) REFERENCES [dbo].[UniformRegistry] ([UniformKey])
GO